package com.huabo.system.mysql.mapper;

import com.hbfk.util.PageInfo;
import com.huabo.system.mysql.entity.TblImplogMySql;

public class TblImplogMapperSqlMySqlConfig {


    public String findByTblImplogList(PageInfo<TblImplogMySql> pageInfo, String username, String type) {

        StringBuffer sqlSb = new StringBuffer("SELECT * FROM (SELECT BUDGET.* FROM (SELECT * FROM TBL_IMP_LOG  WHERE IMPTYPE = '" + type + "' and IMPCREATEUSERNAME = '" + username + "' ");
        sqlSb.append(" order by IMPCREATETIME desc ) BUDGET LIMIT " + pageInfo.getCurrentRecord() + " , " + pageInfo.getPageSize());
        String sql = sqlSb.toString();
        return sql;
    }
}
